USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[KillsInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.KillsInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Kills Table Insert
-- =============================================
CREATE PROCEDURE KillsInsert

		   @KillId int, 
           @RoundId int, 
           @MiniRoundId int, 
           @KillTime datetime, 
           @Attacker_playerId varchar(30), 
           @Attacker_weaponId int, 
           @Attacker_classId int, 
           @Attacker_pos_x float, 
           @Attacker_pos_y float, 
           @Attacker_pos_z float, 
           @Attacker_team int, 
           @Victim_playerId varchar(30), 
           @Victim_pos_x float, 
           @Victim_pos_y float, 
           @Victim_pos_z float, 
           @Victim_team int, 
           @Victim_classId int,
           @MapId int, 
           @CustomKillId int, 
           @LogId int, 
           @DateTime datetime
	

AS
BEGIN

INSERT INTO [Kills]
           ([KillId]
           ,[RoundId]
           ,[MiniRoundId]
           ,[KillTime]
           ,[Attacker_playerId]
           ,[Attacker_weaponId]
           ,[Attacker_classId]
           ,[Attacker_pos_x]
           ,[Attacker_pos_y]
           ,[Attacker_pos_z]
           ,[Attacker_team]
           ,[Victim_playerId]
           ,[Victim_pos_x]
           ,[Victim_pos_y]
           ,[Victim_pos_z]
           ,[Victim_team]
           ,[Victim_classId]
           ,[MapId]
           ,[CustomKillId]
           ,[LogId]
           ,[DateTime])
     VALUES
           (@KillId, 
           @RoundId, 
           @MiniRoundId, 
           @KillTime, 
           @Attacker_playerId, 
           @Attacker_weaponId, 
           @Attacker_classId, 
           @Attacker_pos_x, 
           @Attacker_pos_y, 
           @Attacker_pos_z, 
           @Attacker_team, 
           @Victim_playerId, 
           @Victim_pos_x, 
           @Victim_pos_y, 
           @Victim_pos_z, 
           @Victim_team, 
           @Victim_classId,
           @MapId, 
           @CustomKillId, 
           @LogId, 
           @DateTime)
END
GO
